﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MesGLApp.DAL.MesDB
{
    [Serializable]
    [Table("prod_line_setting")]
    public class ProdLineSetting
    {
        /// <summary>
        /// ID，主键，自键长
        /// </summary>
        [Column("id")]
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int ID { get; set; }


        /// <summary>
        /// 生产线代号
        /// </summary>
        [Column("line_code")]
        public string LineCode { get; set; }

        /// <summary>
        /// 生产线名称
        /// </summary>
        [Column("line_name")]
        public string LineName { get; set; }

        /// <summary>
        /// 对应EXCEL档的名称
        /// </summary>
        [Column("rep_name")]
        public string ReportName { get; set; }

        /// <summary>
        /// EXCEL表中记录生产日期的栏位名称
        /// </summary>
        [Column("prod_date_name")]
        public string ProdDateName { get; set; }

        /// <summary>
        /// 生产线第一站的ID
        /// </summary>
        [Column("begin_site_id")]
        public int BeginSiteID { get; set; }


        /// <summary>
        /// 生产线第一站的名称
        /// </summary>
        [Column("begin_site_name")]
        public string BeginSiteName { get; set; }

        /// <summary>
        /// 生产线最后一站ID
        /// </summary>
        [Column("last_site_id")]
        public int LastSiteID { get; set; }

        /// <summary>
        /// 生产线最后一站站名
        /// </summary>
        [Column("last_site_name")]
        public string LastSiteName { get; set; }

        /// <summary>
        /// 计划完成期限
        /// </summary>
        [Column("comp_days")]
        public decimal? CompDays { get; set; }

        /// <summary>
        /// 建档人
        /// </summary>
        [Column("create_user")]
        public string CreateUser { get; set; }

        /// <summary>
        /// 建档日期
        /// </summary>
        [Column("create_date")]
        public DateTime? CreateDate { get; set; }
    }
}
